Dashboard 03 - Creating Matrix, Map, & Line and Stacked Column chart Visualizations - Part 02 21



In this step, we will continue creating a matrix, map and chart in the 3rd dashboard.


Step 2 - Create Average Police Incidents Per Day & Time of Day Line and Stacked Column chart


To get you started, use the previous map as a template.  Click on the Total Police Incidents by Time of Day, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied map, change it to a  Line and Stacked Column chart and set up as follows:

To create the chart, click the Line and Stacked Column chart icon


Visualizations

Fields

Select the following:

A_KeyMeasures ->  .AVG_Crimes_PerWeekDay  - Under Visualizations, drag & drop it in the Column Values section

A_KeyMeasures ->  .YOY_AVG_Crimes_PerDay%  - Under Visualizations, drag & drop it in the Line Values section

A_KeyMeasures ->  .YOY_AVG_Crimes_PerDay%  - Under Visualizations, drag & drop it in the Tooltips section

Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_hour - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  Time_Of_Day - Under Visualizations, drag & drop it in the Column Series section



Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.AVG_Crimes_PerWeekDay  = Avg Crimes/WeekDay

.YOY_AVG_Crimes_PerDay%  = YOY AVG Crimes/Day

reported_dayofwk = Reported Day of the Week

reported_hour = Reported Hour

Time_Of_Day= Time Of Day



Summary:



Under Format ->  General: X Position = 0 , Y Position = 652 , Width = 605 , Height = 321

Under Format -> Legend ->  Set it to ON , Position = Top Center , Title = OFF , Color = 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers Only

Under Format -> X Axis -> Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis  (Column) -> Position = Left , Scale type = Linear -> Start = 0.1 -> Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Color = 000000 , Stroke Width = 2 , Line Style = Dotted ,   Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> YOY AVG Crimes/Day = 6B007B , Afternoon = F0E199 , Late Night = 41A4FF , Morning = EB895F , Night = 717BC5

Under Format ->  Data Labels ->  Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,

Customize Series  = ON ,

(Select Afternoon ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select Late Night ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select Morning ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select Night ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select YOY ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Average Police Incidents Per Day & Time of Day , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666


Note: Be sure to select/change to Line and Stacked Column chart as shown below:




Filters


None



When finished, save project.





How to Create matrix visualizations in Power BI